Channel: Leila Gharani

Category: Education

Tags: join cellsmagic trick in excelhow tocombine dataconcatenatemicrosoft excel tutorialscombine text and numbersexcel for analystsquickly combine multiple textxelplusvisadvanced excel tricksxelplusconcatenate excelkeep number formattingquickly combine multiple cellsexcel tips and trickscombine cellsampersandmicrosoft excelleila gharaniexcel 2016excel 2019microsoft 365excel 2013excel online courseexcel 365

Description: In this video I'll show you how you can combine data (text and numbers) from multiple cells into one cell in Microsoft Excel. You'll learn how to use the TEXT function in Excel to even apply number formatting to the combined cell. I'll show you different approaches without using the Concatenate Function. We'll do it much easier. I'll also give you a bonus tip on how you can have a text and number combination in a cell and still use formulas on this cell: the Excel trick we'll use here is with custom number formatting. 🌍 My Online Excel Courses ► xelplus.com/courses 00:00 Combine Text & Numbers From 2 or More Cells Into 1 Cell 00:30 How to Combine Text and Numbers 02:53 Combine Text & Numbers WITH Formatting 05:00 Bonus: Add Text to Numbers in Excel 07:07 Wrap Up 🔻Download the file and blog post: xelplus.com/excel-combine-text-number 🎬 Learn more about custom number formatting: youtu.be/68Tet_8BNB8 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel